Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <!DOCTYPE html>
9 <html>
10
11 <head>
12 <meta charset="utf-8">
13 <meta name="viewport" content="width=device-width, initial-scale=1.0">
14 <title>school management system</title>
15 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
16 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
17 <link href="assets/css/loader.css" rel="stylesheet" />
18 <script src="assets/js/canvasjs.min.js"></script>
19 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
20 <script src="assets/js/jquery-3.2.1.js"></script>
21
22 <body >
23 <!--end of heading section-->
24 <ul class="nav navbar-right top-nav">
25 <div class="dropdown">
26 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
27 <?php
28 //Check to see if the user is logged in.if not redirect user to the loging page.
29
30 if(isset($_SESSION['fname']))
31 {
32 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
33 }else{
34 echo "<script type='text/javascript'>
35 alert( 'You must Log in to use the system');
36 </script>";
37 echo "<script>
38 window.location = 'index.php'
39 </script>";
40 }
41 ?>
42 <span class="caret"></span></button>
43 <ul class="dropdown-menu">
44 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
45 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
46 <li class="divider"></li>
47 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
48 </ul>
49 </div>
50 </ul>
51 <!--************************************************-->
52 <div style="
53 font-family:Nyala, Arial;
54 text-align: left;
55 background-color: #526F35;
56 padding: 20px;
57 color:white;
58 width: 100%;
59 height: 150px;">
60 <!--This codes to load the image loader-->
61 <div id="loading">
62 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
63 </div>
64 <!--this is the heading section-->
65 <h2>
66 <?php
67 $sql="SELECT * FROM companyinfo";
68 $result=mysqli_query($db,$sql) or die("error getting data");
69 $num_rows=mysqli_num_rows($result);
70 while($row=mysqli_fetch_array($result))
71 {
72 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
73 $cname = $row['cname'];
74 $cemail = $row['cemail'];
75 $ccontact = $row['ccontact'];
76 $clocation = $row['clocation'];
77 }?>
78 <?php
79 echo $cname;
80 ?>
81
82 <div style="float:right; font-size:20px;text-align:right;">
83
84 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
85 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
86 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
87
88 </div>
89 </h2>
90 </div>
91 <!--end of heading section-->
92
93 <div>
94 <ul class="nav nav-tabs">
95 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
96 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
97 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
98 <li class="active"><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
99 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
100 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
101 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
102 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
103 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
104 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
105
106 </ul>
107 <div class="tab-content">
108 <div class="tab-pane active" role="tabpanel" id="tab-1">
109
110 <p>
111 <div class="table-responsive" >
112 <!--****************************************************************************-->
113 <div class="container" style="width:100%">
114
115 <ul class="nav nav-tabs">
116 <li class="active"><a href="#">New Course<img src="assets/img/new.png"> </a></li>
117
118 <li><a href="editcourse.php">Edit course <img src="assets/img/update2.png"> </a></li>
119 <li><a href="csvtesting.php">Import/Export CSV<img src="assets/img/export.png"></a></li>
120 <li><a href="deletecourse.PHP">Delete <img src="assets/img/delete2.png"></a></li>
121 <li><a href="#">Manage Course </a></li>
122
123 </ul>
124 <br>
125
126 </div>
127
128 <!--*************************************************************************************************************************-->
129 <div class="container-fluid">
130 <div class="row">
131 <div class="col-lg-6 col-lg-offset-3">
132 <div class="panel panel-primary">
133 <div class="panel-heading">Add new Course</div>
134
135 <!-- /.panel-heading -->
136 <div class="panel-body">
137 <div class="table">
138
139
140 <form action="course.php" method="POST" enctype="multipart/form-data">
141 <h4>Course Details</h4>
142 <label>Class Name</label>
143 <input type="text" name="coursename" class="form-control">
144 <label>Exam Body</label>
145 <input type="text" name="exambody" class="form-control" placeholder="internal/knec">
146 <label>Duration</label>
147 <input type="text" name="duration" class="form-control" placeholder="1 year">
148 <label>Fee Payable[Per Year]</label>
149 <input type="number" name="feepayable" class="form-control" min="0" value="0">
150 <label> Department</label>
151 <select name="department_id" class="form-control">
152 <?php
153 include('connect.php');
154 $sql1="SELECT departmentname FROM departments";
155 $records1=mysqli_query($db,$sql1);
156 while($row=mysqli_fetch_array($records1))
157 {
158 echo "<option>".$row['departmentname']."</option>";
159 }
160 ?>
161 </select><a href="departments.php">Check department name</a> <br>
162
163 <input type="submit" name="register" value="Save Record" class="btn btn-success">
164 </form>
165 </div>
166 </div>
167 </div>
168 </div>
169 </div>
170
171 <!--****************************************************************************-->
172 <?php
173 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
174 if (isset($_POST['register'])){
175
176 $department_id=$_POST['department_id'];
177
178 $xx=$_POST['department_id'];
179 $sql="SELECT * FROM departments WHERE departmentname='$xx'";
180 $user_query=mysqli_query($db,$sql) or die("error getting data");
181 while($row = mysqli_fetch_array($user_query)){
182 $department_id = $row['department_id'];}
183
184 $coursename=$_POST['coursename'];
185 $exambody=$_POST['exambody'];
186 $duration=$_POST['duration'];
187 $feepayable=$_POST['feepayable'];
188
189 mysqli_query($conn,"INSERT INTO course(department_id,coursename,exambody,duration,feepayable ) VALUES ('$department_id','$coursename','$exambody','$duration','$feepayable')") or die(mysqli_error());
190
191 ?>
192 <?php
193 $query="SELECT * FROM course";
194 $records2=mysqli_query($db,$query);
195 while($rec=mysqli_fetch_array($records2))
196 {
197 $id = $rec['course_id'];
198 }?>
199
200 <script>
201
202 alert('Succsessfully Save.');
203 window.location = "course.php?id=<?php echo $id;?>";
204 </script>
205 <?php }?>
206 <!--*******************************try add parent's details******************************************************-->
207 </div>
208 </div>
209 </div>
210 <!-- /.container-fluid -->
211 </div>
212 <!-- /#page-wrapper -->
213 </div>
214 <form action="course.php" method="POST" enctype="multipart/form-data" name="upload_excel" class="form-horizontal">
215 <div class="table-responsive">
216 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
217
218 <thead>
219 <tr>
220 <th></th>
221 <th><center>Class ID</center></th>
222 <th><center>Class Name</center></th>
223 <th><center>Duration </center></th>
224 <th><center>Fee Payable[Annual]</center></th>
225 <th><center>Exam Body</center></th>
226
227 <th><center>Edit</center></th>
228 <th><center>Delete</center></th>
229 <script src="assets/js/jquery.dataTables.min.js"></script>
230 <script src="assets/js/DT_bootstrap.js"></script>
231 <th></th>
232 </tr>
233 </thead>
234 <tbody>
235 <?php
236 $sql ="SELECT * from course";
237 $user_query=mysqli_query($db,$sql) or die("error getting data");
238 while($row = mysqli_fetch_array($user_query)){
239 $id = $row['course_id'];
240
241 ?>
242 <tr>
243 <td width="30">
244 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="radio" value="<?php echo $id; ?>">
245 </td>
246 <td><center><?php echo $row['course_id']; ?></center></td>
247 <td><center><?php echo $row['coursename']; ?></center></td>
248 <td><center><?php echo $row['duration']; ?></center></td>
249 <td><center><?php echo $row['feepayable']; ?></center></td>
250 <td><center><?php echo $row['exambody']; ?></center></td>
251
252 <td>
253 <center><a href="editcourse.php <?php echo '?id='.$id; ?>" class="btn btn-success"><i class="glyphicon glyphicon-edit" name="register"></i>Edit</a></center></td>
254
255 <td><center><a href="deletecourse.php <?php echo '?id='.$id; ?>" class="btn btn-danger"><i class="glyphicon glyphicon-trash" name="register"></i>delete</a></center></td>
256
257
258 </tr>
259 <?php } ?>
260 </tbody>
261 </table>
262 </form>
263 </div><br>
264
265
266 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
267 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
268 </div>
269 <script src="assets/js/jquery.min.js"></script>
270 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
271 <script src="assets/js/affix.js"></script>
272 <script src="assets/js/alert.js"></script>
273 <script src="assets/js/alert1.js"></script>
274 <script src="assets/js/bootstrap.js"></script>
275 <script src="assets/js/bootstrap.min.js"></script>
276 <script src="assets/js/bootstrap-datepicker.js"></script>
277 <script src="assets/js/bootstrap-wysihtml5.js"></script>
278 <script src="assets/js/button.js"></script>
279 <script src="assets/js/carousel.js"></script>
280 <script src="assets/js/chosen.jquery.min.js"></script>
281 <script src="assets/js/ckeditor.js"></script>
282 <script src="assets/js/collapse.js"></script>
283 <script src="assets/js/color.js"></script>
284 <script src="assets/js/dropdown.js"></script>
285 <script src="assets/js/DT_bootstrap.js"></script>
286 <script src="assets/js/dynamic.js"></script>
287 <script src="assets/js/ie-emulation-modes-warning.js"></script>
288 <script src="assets/js/jquery.dataTables.js"></script>
289 <script src="assets/js/jquery.dataTables.min.js"></script>
290 <script src="assets/js/jquery.dialog.js"></script>
291 <script src="assets/js/jquery.hoverdir.js"></script>
292 <script src="assets/js/jquery.jgrowl.js"></script>
293 <script src="assets/js/jquery.knob.js"></script>
294 <script src="assets/js/jquery.uniform.min.js"></script>
295 <script src="assets/js/jquery-1.8.3.min.js"></script>
296 <script src="assets/js/jquery-1.9.1.js"></script>
297 <script src="assets/js/jquery-1.9.1.min.js"></script>
298 <script src="assets/js/jquery-1.10.2.js"></script>
299 <script src="assets/js/jquery-1.11.0.js"></script>
300 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
301 <script src="assets/js/jquery-ui-1.10.3.js"></script>
302 <script src="assets/js/modal.js"></script>
303 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
304 <script src="assets/js/myjquery.js"></script>
305 <script src="assets/js/myjquery1.js"></script>
306 <script src="assets/js/npm.js"></script>
307 <script src="assets/js/popover.js"></script>
308 <script src="assets/js/profile.js"></script>
309 <script src="assets/js/raphael-min.js"></script>
310 <script src="assets/js/sb-admin-2.js"></script>
311 <script src="assets/js/scripts.js"></script>
312 <script src="assets/js/scrollspy.js"></script>
313 <script src="assets/js/tab.js"></script>
314 <script src="assets/js/tooltip.js"></script>
315 <script src="assets/js/transition.js"></script>
316 <script src="assets/js/wysihtml5-0.3.0.js"></script>
317 <script language="javascript" type="text/javascript">
318 $(window).load(function()
319 {
320 $('#loading').hide();
321 });
322 </script>
323 </body>
324
325 </html>